[dbo].[ChangeProperty]

Property	Value
Created	10:31:16 AM Tuesday, March 02, 2010
Last Modified	11:40:01 AM Monday, February 20, 2012

Property

Value

Created

10:31:16 AM Tuesday, March 02, 2010

Last Modified

11:40:01 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_ChangeProperty: ChangeLogKey\PropertyName$	ChangeLogKey	uniqueidentifier	16
$Cluster Primary Key PK_ChangeProperty: ChangeLogKey\PropertyName$	PropertyName	nvarchar(100)	200
	OriginalValue	nvarchar(250)	500
	OriginalDescription	nvarchar(250)	500
	CurrentValue	nvarchar(250)	500
	CurrentDescription	nvarchar(250)	500
	MarkedForDeleteOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_ChangeProperty: ChangeLogKey\PropertyName$

ChangeLogKey

uniqueidentifier

$Cluster Primary Key PK_ChangeProperty: ChangeLogKey\PropertyName$

PropertyName

nvarchar(100)

200

OriginalValue

nvarchar(250)

500

OriginalDescription

nvarchar(250)

500

CurrentValue

nvarchar(250)

500

CurrentDescription

nvarchar(250)

500

MarkedForDeleteOn

datetime

	Name	Columns	Unique
$Cluster Primary Key PK_ChangeProperty: ChangeLogKey\PropertyName$	PK_ChangeProperty	ChangeLogKey, PropertyName

Name

Columns

Unique

$Cluster Primary Key PK_ChangeProperty: ChangeLogKey\PropertyName$

PK_ChangeProperty

ChangeLogKey, PropertyName

Name	Columns
FK_ChangeProperty_ChangeLog	ChangeLogKey->[dbo].[ChangeLog].[ChangeLogKey]

Name

Columns

FK_ChangeProperty_ChangeLog

ChangeLogKey->[dbo].[ChangeLog].[ChangeLogKey]

SQL Script

CREATE TABLE [dbo].[ChangeProperty]
(
[ChangeLogKey] [uniqueidentifier] NOT NULL,
[PropertyName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OriginalValue] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OriginalDescription] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CurrentValue] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CurrentDescription] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ChangeProperty] ADD CONSTRAINT [PK_ChangeProperty] PRIMARY KEY CLUSTERED ([ChangeLogKey], [PropertyName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ChangeProperty] ADD CONSTRAINT [FK_ChangeProperty_ChangeLog] FOREIGN KEY ([ChangeLogKey]) REFERENCES [dbo].[ChangeLog] ([ChangeLogKey])
GO